Overview
Brought to you by YData
Dataset statistics
| Number of variables | 33 |
|---|---|
| Number of observations | 1904354 |
| Missing cells | 30 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 165.6 MiB |
| Average record size in memory | 91.2 B |
Variable types
| Numeric | 19 |
|---|---|
| Boolean | 1 |
| Categorical | 10 |
| DateTime | 3 |
NOMBRE has a high cardinality: 955 distinct values | High cardinality |
NOMLARGO has a high cardinality: 983 distinct values | High cardinality |
RFC has a high cardinality: 762 distinct values | High cardinality |
NLINEA has a high cardinality: 1015 distinct values | High cardinality |
FLIQ has a high cardinality: 5913 distinct values | High cardinality |
IINSTR has a high cardinality: 132 distinct values | High cardinality |
AÑO_FLIQ is highly overall correlated with AÑO_FVENCE and 1 other fields | High correlation |
AÑO_FVENCE is highly overall correlated with AÑO_FLIQ and 1 other fields | High correlation |
AÑO_OPE is highly overall correlated with AÑO_FLIQ and 1 other fields | High correlation |
CPZO_A is highly overall correlated with CPZO_DE | High correlation |
CPZO_DE is highly overall correlated with CPZO_A | High correlation |
DIA_FLIQ is highly overall correlated with DIA_FVENCE and 1 other fields | High correlation |
DIA_FVENCE is highly overall correlated with DIA_FLIQ and 1 other fields | High correlation |
DIA_OPE is highly overall correlated with DIA_FLIQ and 1 other fields | High correlation |
ESPROVEED is highly overall correlated with TIPO_PERSONA | High correlation |
ICONTRATO is highly overall correlated with NUMERO_CLIENTE | High correlation |
ITINSTR is highly overall correlated with MONEDA and 1 other fields | High correlation |
MES_FLIQ is highly overall correlated with MES_FVENCE and 1 other fields | High correlation |
MES_FVENCE is highly overall correlated with MES_FLIQ and 1 other fields | High correlation |
MES_OPE is highly overall correlated with MES_FLIQ and 1 other fields | High correlation |
MONEDA is highly overall correlated with ITINSTR and 1 other fields | High correlation |
MONTO is highly overall correlated with MONTO_ASIGNADO and 1 other fields | High correlation |
MONTO_ASIGNADO is highly overall correlated with MONTO and 1 other fields | High correlation |
MONTO_REAL is highly overall correlated with MONTO and 1 other fields | High correlation |
NTINSTR is highly overall correlated with ITINSTR and 1 other fields | High correlation |
NUMERO_CLIENTE is highly overall correlated with ICONTRATO | High correlation |
TIPO_PERSONA is highly overall correlated with ESPROVEED | High correlation |
IINSTR is highly imbalanced (69.1%) | Imbalance |
ITINSTR is highly imbalanced (72.4%) | Imbalance |
NTINSTR is highly imbalanced (71.1%) | Imbalance |
MONEDA is highly imbalanced (> 99.9%) | Imbalance |
CPZO_DE is highly skewed (γ1 = 236.5402493) | Skewed |
CPZO_A is highly skewed (γ1 = 235.002316) | Skewed |
PLAZOREF is highly skewed (γ1 = 51.32852076) | Skewed |
AÑO_FVENCE is highly skewed (γ1 = 133.3760011) | Skewed |
TASA is highly skewed (γ1 = 104.6177444) | Skewed |
MONTO is highly skewed (γ1 = 133.805481) | Skewed |
MONTO_REAL is highly skewed (γ1 = 94.71003723) | Skewed |
PLAZOREF has 1837810 (96.5%) zeros | Zeros |
TASA has 55531 (2.9%) zeros | Zeros |
MONTO_ASIGNADO has 28357 (1.5%) zeros | Zeros |
Reproduction
| Analysis started | 2025-02-26 23:21:57.753927 |
|---|---|
| Analysis finished | 2025-02-26 23:25:12.857304 |
| Duration | 3 minutes and 15.1 seconds |
| Software version | ydata-profiling vv4.12.2 |
| Download configuration | config.json |
Variables
NUMERO_CLIENTE
Real number (ℝ)
High correlation
| Distinct | 1016 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 816827.81 |
| Minimum | 5 |
|---|---|
| Maximum | 9001793 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.3 MiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 9080 |
| Q1 | 909016 |
| median | 1060445 |
| Q3 | 1063955 |
| 95-th percentile | 1064796 |
| Maximum | 9001793 |
| Range | 9001788 |
| Interquartile range (IQR) | 154939 |
Descriptive statistics
| Standard deviation | 425303.94 |
|---|---|
| Coefficient of variation (CV) | 0.52067759 |
| Kurtosis | -0.010963404 |
| Mean | 816827.81 |
| Median Absolute Deviation (MAD) | 4435 |
| Skewness | -1.2781954 |
| Sum | 1.5555293 × 1012 |
| Variance | 1.8088344 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 20000 | 119698 | 6.3% |
| 30000 | 118531 | 6.2% |
| 1064343 | 106285 | 5.6% |
| 989141 | 47298 | 2.5% |
| 1064456 | 42101 | 2.2% |
| 91000 | 23003 | 1.2% |
| 1062065 | 22769 | 1.2% |
| 71000 | 20903 | 1.1% |
| 920095 | 19501 | 1.0% |
| 905487 | 17529 | 0.9% |
| Other values (1006) | 1366736 |
| Value | Count | Frequency (%) |
| 5 | 24 | < 0.1% |
| 31 | 10148 | |
| 80 | 5689 | |
| 102 | 3550 | 0.2% |
| 145 | 7826 | |
| 161 | 6797 | |
| 315 | 9346 | |
| 412 | 13799 | |
| 811 | 4171 | 0.2% |
| 821 | 4342 | 0.2% |
| Value | Count | Frequency (%) |
| 9001793 | 2 | < 0.1% |
| 6009449 | 11 | < 0.1% |
| 2002989 | 1 | < 0.1% |
| 1065877 | 32 | < 0.1% |
| 1065866 | 103 | |
| 1065862 | 88 | |
| 1065860 | 15 | < 0.1% |
| 1065859 | 101 | |
| 1065855 | 4 | < 0.1% |
| 1065852 | 175 |
ESPROVEED
Boolean
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 1185079 | |
| False | 719275 |
TIPO_PERSONA
Categorical
High correlation
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| Moral Nacional no Gravable | |
|---|---|
| Cuentas Propias | |
| Moral Nacional Gravable | |
| Moral Nal.No Gravable (Fondos) | 30654 |
| Moral Extranjera Pais c/tratad | 1089 |
Length
| Max length | 30 |
|---|---|
| Median length | 26 |
| Mean length | 23.925427 |
| Min length | 15 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Moral Nacional no Gravable |
|---|---|
| 2nd row | Cuentas Propias |
| 3rd row | Moral Nacional no Gravable |
| 4th row | Cuentas Propias |
| 5th row | Moral Nacional no Gravable |
Common Values
| Value | Count | Frequency (%) |
| Moral Nacional no Gravable | 1382113 | |
| Cuentas Propias | 325775 | 17.1% |
| Moral Nacional Gravable | 164723 | 8.6% |
| Moral Nal.No Gravable (Fondos) | 30654 | 1.6% |
| Moral Extranjera Pais c/tratad | 1089 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| moral | 1578579 | |
| gravable | 1577490 | |
| nacional | 1546836 | |
| no | 1382113 | |
| cuentas | 325775 | 4.8% |
| propias | 325775 | 4.8% |
| nal.no | 30654 | 0.5% |
| fondos | 30654 | 0.5% |
| extranjera | 1089 | < 0.1% |
| pais | 1089 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 8514880 | |
| o | 4925265 | |
| 4896789 | ||
| l | 4733559 | |
| r | 3485111 | 7.6% |
| n | 3286467 | 7.2% |
| e | 1904354 | 4.2% |
| i | 1873700 | 4.1% |
| N | 1608144 | 3.5% |
| M | 1578579 | 3.5% |
| Other values (19) | 8755634 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 45562482 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 8514880 | |
| o | 4925265 | |
| 4896789 | ||
| l | 4733559 | |
| r | 3485111 | 7.6% |
| n | 3286467 | 7.2% |
| e | 1904354 | 4.2% |
| i | 1873700 | 4.1% |
| N | 1608144 | 3.5% |
| M | 1578579 | 3.5% |
| Other values (19) | 8755634 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 45562482 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 8514880 | |
| o | 4925265 | |
| 4896789 | ||
| l | 4733559 | |
| r | 3485111 | 7.6% |
| n | 3286467 | 7.2% |
| e | 1904354 | 4.2% |
| i | 1873700 | 4.1% |
| N | 1608144 | 3.5% |
| M | 1578579 | 3.5% |
| Other values (19) | 8755634 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 45562482 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 8514880 | |
| o | 4925265 | |
| 4896789 | ||
| l | 4733559 | |
| r | 3485111 | 7.6% |
| n | 3286467 | 7.2% |
| e | 1904354 | 4.2% |
| i | 1873700 | 4.1% |
| N | 1608144 | 3.5% |
| M | 1578579 | 3.5% |
| Other values (19) | 8755634 |
NOMBRE
Categorical
High cardinality
| Distinct | 955 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.7 MiB |
| PASIVO | 119698 |
|---|---|
| Proveedor Papel NAFIN | 118531 |
| PROGRAMA CETESDIRECTO | 106285 |
| FIDEICOMISOS | 70534 |
| SANTANDER | 47298 |
| Other values (950) |
Length
| Max length | 26 |
|---|---|
| Median length | 21 |
| Mean length | 13.788014 |
| Min length | 2 |
Unique
| Unique | 74 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | BANXICO |
|---|---|
| 2nd row | GARANTIAS CREDITO |
| 3rd row | BANXICO |
| 4th row | GARANTIAS CREDITO |
| 5th row | BANXICO |
Common Values
| Value | Count | Frequency (%) |
| PASIVO | 119698 | 6.3% |
| Proveedor Papel NAFIN | 118531 | 6.2% |
| PROGRAMA CETESDIRECTO | 106285 | 5.6% |
| FIDEICOMISOS | 70534 | 3.7% |
| SANTANDER | 47298 | 2.5% |
| SEGUROS BBVA BANCOMER SA. | 42101 | 2.2% |
| Guber Vencimiento | 23003 | 1.2% |
| SEGUROS BBVA BANCOMER | 22769 | 1.2% |
| TESORERIA | 20903 | 1.1% |
| BBVA MEXICO | 19501 | 1.0% |
| Other values (945) | 1313731 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 167720 | 4.1% | |
| nafin | 130325 | 3.2% |
| pasivo | 119698 | 2.9% |
| proveedor | 118532 | 2.9% |
| papel | 118531 | 2.9% |
| fideicomisos | 117807 | 2.9% |
| programa | 106286 | 2.6% |
| cetesdirecto | 106285 | 2.6% |
| fiso | 101163 | 2.5% |
| bbva | 88801 | 2.2% |
| Other values (1121) | 2907643 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2240493 | 8.5% | |
| A | 2175471 | 8.3% |
| E | 1792984 | 6.8% |
| I | 1772924 | 6.8% |
| S | 1626491 | 6.2% |
| O | 1623945 | 6.2% |
| R | 1293985 | 4.9% |
| N | 1235662 | 4.7% |
| C | 1169398 | 4.5% |
| B | 900969 | 3.4% |
| Other values (57) | 10424938 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 26257260 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2240493 | 8.5% | |
| A | 2175471 | 8.3% |
| E | 1792984 | 6.8% |
| I | 1772924 | 6.8% |
| S | 1626491 | 6.2% |
| O | 1623945 | 6.2% |
| R | 1293985 | 4.9% |
| N | 1235662 | 4.7% |
| C | 1169398 | 4.5% |
| B | 900969 | 3.4% |
| Other values (57) | 10424938 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 26257260 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2240493 | 8.5% | |
| A | 2175471 | 8.3% |
| E | 1792984 | 6.8% |
| I | 1772924 | 6.8% |
| S | 1626491 | 6.2% |
| O | 1623945 | 6.2% |
| R | 1293985 | 4.9% |
| N | 1235662 | 4.7% |
| C | 1169398 | 4.5% |
| B | 900969 | 3.4% |
| Other values (57) | 10424938 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 26257260 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2240493 | 8.5% | |
| A | 2175471 | 8.3% |
| E | 1792984 | 6.8% |
| I | 1772924 | 6.8% |
| S | 1626491 | 6.2% |
| O | 1623945 | 6.2% |
| R | 1293985 | 4.9% |
| N | 1235662 | 4.7% |
| C | 1169398 | 4.5% |
| B | 900969 | 3.4% |
| Other values (57) | 10424938 |
NOMLARGO
Categorical
High cardinality
| Distinct | 983 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.7 MiB |
| PASIVO | 119698 |
|---|---|
| Proveedor Papel para Emision de Papel | 118531 |
| NAFIN, SNC IBD EN SU CALIDAD DE COM DE LOS CTES DEL CANAL DE DIST CETES | 106285 |
| SEGUROS BBVA BANCOMER SA DE CV GRUPO FINANCIERO BBVA BANCOMER | 64870 |
| BANCO SANTANDER DE NEGOCIOS MEXICO,S.A. | 47298 |
| Other values (978) |
Length
| Max length | 71 |
|---|---|
| Median length | 63 |
| Mean length | 46.876481 |
| Min length | 6 |
Unique
| Unique | 93 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | BANCO DE MEXICO |
|---|---|
| 2nd row | GARANTIAS CREDITO |
| 3rd row | BANCO DE MEXICO |
| 4th row | GARANTIAS CREDITO |
| 5th row | BANCO DE MEXICO |
Common Values
| Value | Count | Frequency (%) |
| PASIVO | 119698 | 6.3% |
| Proveedor Papel para Emision de Papel | 118531 | 6.2% |
| NAFIN, SNC IBD EN SU CALIDAD DE COM DE LOS CTES DEL CANAL DE DIST CETES | 106285 | 5.6% |
| SEGUROS BBVA BANCOMER SA DE CV GRUPO FINANCIERO BBVA BANCOMER | 64870 | 3.4% |
| BANCO SANTANDER DE NEGOCIOS MEXICO,S.A. | 47298 | 2.5% |
| Gubernamental Vencimiento MN. | 23003 | 1.2% |
| TESORERIA FONDEO | 20903 | 1.1% |
| FDO. PENS. Y PRIMAS ANTIGUEDAD N. /50145 | 20803 | 1.1% |
| BBVA M�XICO, S.A. INSTITUCI�N DE BANCA MULTIPLE, GRUPO FINANCIERO BBVA | 19501 | 1.0% |
| CBM BANCO, SA, IBM, INTEGRANTE DEL GRUPO FINANCIERO CITIBANAMEX | 17529 | 0.9% |
| Other values (973) | 1345933 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| de | 2071300 | 13.9% |
| s.a | 654762 | 4.4% |
| c.v | 526507 | 3.5% |
| del | 322047 | 2.2% |
| nafin | 298951 | 2.0% |
| en | 267337 | 1.8% |
| fondo | 243974 | 1.6% |
| papel | 237062 | 1.6% |
| bbva | 209670 | 1.4% |
| grupo | 200679 | 1.3% |
| Other values (1338) | 9849321 |
Most occurring characters
| Value | Count | Frequency (%) |
| 13072346 | ||
| A | 7419956 | 8.3% |
| E | 6782250 | 7.6% |
| I | 5957830 | 6.7% |
| O | 5258738 | 5.9% |
| N | 5030501 | 5.6% |
| C | 4855044 | 5.4% |
| S | 4808265 | 5.4% |
| D | 4647667 | 5.2% |
| . | 3918633 | 4.4% |
| Other values (59) | 27518185 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 89269415 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 13072346 | ||
| A | 7419956 | 8.3% |
| E | 6782250 | 7.6% |
| I | 5957830 | 6.7% |
| O | 5258738 | 5.9% |
| N | 5030501 | 5.6% |
| C | 4855044 | 5.4% |
| S | 4808265 | 5.4% |
| D | 4647667 | 5.2% |
| . | 3918633 | 4.4% |
| Other values (59) | 27518185 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 89269415 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 13072346 | ||
| A | 7419956 | 8.3% |
| E | 6782250 | 7.6% |
| I | 5957830 | 6.7% |
| O | 5258738 | 5.9% |
| N | 5030501 | 5.6% |
| C | 4855044 | 5.4% |
| S | 4808265 | 5.4% |
| D | 4647667 | 5.2% |
| . | 3918633 | 4.4% |
| Other values (59) | 27518185 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 89269415 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 13072346 | ||
| A | 7419956 | 8.3% |
| E | 6782250 | 7.6% |
| I | 5957830 | 6.7% |
| O | 5258738 | 5.9% |
| N | 5030501 | 5.6% |
| C | 4855044 | 5.4% |
| S | 4808265 | 5.4% |
| D | 4647667 | 5.2% |
| . | 3918633 | 4.4% |
| Other values (59) | 27518185 |
RFC
Categorical
High cardinality
| Distinct | 762 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.7 MiB |
| NFI3406305T0 | |
|---|---|
| SBB961118TIA | 64870 |
| BSM941122TE6 | 47298 |
| CJF950204TL0 | 46913 |
| INF7205011ZA | 38056 |
| Other values (757) |
Length
| Max length | 13 |
|---|---|
| Median length | 12 |
| Mean length | 12.000781 |
| Min length | 12 |
Unique
| Unique | 60 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | BNM840515VB2 |
|---|---|
| 2nd row | NFI3406305T0 |
| 3rd row | BNM840515VB2 |
| 4th row | NFI3406305T0 |
| 5th row | BNM840515VB2 |
Common Values
| Value | Count | Frequency (%) |
| NFI3406305T0 | 574866 | |
| SBB961118TIA | 64870 | 3.4% |
| BSM941122TE6 | 47298 | 2.5% |
| CJF950204TL0 | 46913 | 2.5% |
| INF7205011ZA | 38056 | 2.0% |
| NFF930518F76 | 23781 | 1.2% |
| DBM000228J35 | 23073 | 1.2% |
| BBA830831LJ2 | 22886 | 1.2% |
| IPA9901206D2 | 21976 | 1.2% |
| IMS421231I45 | 21569 | 1.1% |
| Other values (752) | 1019066 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| nfi3406305t0 | 574866 | |
| sbb961118tia | 64870 | 3.4% |
| bsm941122te6 | 47298 | 2.5% |
| cjf950204tl0 | 46913 | 2.5% |
| inf7205011za | 38056 | 2.0% |
| nff930518f76 | 23781 | 1.2% |
| dbm000228j35 | 23073 | 1.2% |
| bba830831lj2 | 22886 | 1.2% |
| ipa9901206d2 | 21976 | 1.2% |
| ims421231i45 | 21569 | 1.1% |
| Other values (752) | 1019066 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 3998708 | |
| 3 | 1700014 | 7.4% |
| 1 | 1609858 | 7.0% |
| 5 | 1337309 | 5.9% |
| 6 | 1231105 | 5.4% |
| F | 1157422 | 5.1% |
| 4 | 1131869 | 5.0% |
| 2 | 1110133 | 4.9% |
| I | 998597 | 4.4% |
| 9 | 980892 | 4.3% |
| Other values (27) | 7597828 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 22853735 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3998708 | |
| 3 | 1700014 | 7.4% |
| 1 | 1609858 | 7.0% |
| 5 | 1337309 | 5.9% |
| 6 | 1231105 | 5.4% |
| F | 1157422 | 5.1% |
| 4 | 1131869 | 5.0% |
| 2 | 1110133 | 4.9% |
| I | 998597 | 4.4% |
| 9 | 980892 | 4.3% |
| Other values (27) | 7597828 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 22853735 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3998708 | |
| 3 | 1700014 | 7.4% |
| 1 | 1609858 | 7.0% |
| 5 | 1337309 | 5.9% |
| 6 | 1231105 | 5.4% |
| F | 1157422 | 5.1% |
| 4 | 1131869 | 5.0% |
| 2 | 1110133 | 4.9% |
| I | 998597 | 4.4% |
| 9 | 980892 | 4.3% |
| Other values (27) | 7597828 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 22853735 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3998708 | |
| 3 | 1700014 | 7.4% |
| 1 | 1609858 | 7.0% |
| 5 | 1337309 | 5.9% |
| 6 | 1231105 | 5.4% |
| F | 1157422 | 5.1% |
| 4 | 1131869 | 5.0% |
| 2 | 1110133 | 4.9% |
| I | 998597 | 4.4% |
| 9 | 980892 | 4.3% |
| Other values (27) | 7597828 |
NLINEA
Categorical
High cardinality
| Distinct | 1015 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.7 MiB |
| 00020000 | 119698 |
|---|---|
| 00030000 | 118531 |
| 1064343 | 106285 |
| 989141 | 47298 |
| 1064456 | 42101 |
| Other values (1010) |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 7.1961836 |
| Min length | 1 |
Unique
| Unique | 112 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 01040153 |
|---|---|
| 2nd row | 00051000 |
| 3rd row | 01040153 |
| 4th row | 00051000 |
| 5th row | 01040153 |
Common Values
| Value | Count | Frequency (%) |
| 00020000 | 119698 | 6.3% |
| 00030000 | 118531 | 6.2% |
| 1064343 | 106285 | 5.6% |
| 989141 | 47298 | 2.5% |
| 1064456 | 42101 | 2.2% |
| 00009070 | 30654 | 1.6% |
| 91000 | 23003 | 1.2% |
| 01062065 | 22769 | 1.2% |
| 00071000 | 20903 | 1.1% |
| 920095 | 19501 | 1.0% |
| Other values (1005) | 1353611 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 00020000 | 119698 | 6.3% |
| 00030000 | 118531 | 6.2% |
| 1064343 | 106285 | 5.6% |
| 989141 | 47298 | 2.5% |
| 1064456 | 42101 | 2.2% |
| 00009070 | 30654 | 1.6% |
| 91000 | 23003 | 1.2% |
| 01062065 | 22769 | 1.2% |
| 00071000 | 20903 | 1.1% |
| 920095 | 19501 | 1.0% |
| Other values (1004) | 1353581 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4881940 | |
| 1 | 2056975 | |
| 6 | 1442421 | 10.5% |
| 4 | 1157847 | 8.4% |
| 3 | 1024815 | 7.5% |
| 5 | 687489 | 5.0% |
| 9 | 670445 | 4.9% |
| 2 | 656380 | 4.8% |
| 7 | 614103 | 4.5% |
| 8 | 511636 | 3.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 13704081 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 4881940 | |
| 1 | 2056975 | |
| 6 | 1442421 | 10.5% |
| 4 | 1157847 | 8.4% |
| 3 | 1024815 | 7.5% |
| 5 | 687489 | 5.0% |
| 9 | 670445 | 4.9% |
| 2 | 656380 | 4.8% |
| 7 | 614103 | 4.5% |
| 8 | 511636 | 3.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 13704081 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 4881940 | |
| 1 | 2056975 | |
| 6 | 1442421 | 10.5% |
| 4 | 1157847 | 8.4% |
| 3 | 1024815 | 7.5% |
| 5 | 687489 | 5.0% |
| 9 | 670445 | 4.9% |
| 2 | 656380 | 4.8% |
| 7 | 614103 | 4.5% |
| 8 | 511636 | 3.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 13704081 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 4881940 | |
| 1 | 2056975 | |
| 6 | 1442421 | 10.5% |
| 4 | 1157847 | 8.4% |
| 3 | 1024815 | 7.5% |
| 5 | 687489 | 5.0% |
| 9 | 670445 | 4.9% |
| 2 | 656380 | 4.8% |
| 7 | 614103 | 4.5% |
| 8 | 511636 | 3.7% |
ICONTRATO
Real number (ℝ)
High correlation
| Distinct | 1016 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 816827.81 |
| Minimum | 5 |
|---|---|
| Maximum | 9001793 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.3 MiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 9080 |
| Q1 | 909016 |
| median | 1060445 |
| Q3 | 1063955 |
| 95-th percentile | 1064796 |
| Maximum | 9001793 |
| Range | 9001788 |
| Interquartile range (IQR) | 154939 |
Descriptive statistics
| Standard deviation | 425303.94 |
|---|---|
| Coefficient of variation (CV) | 0.52067759 |
| Kurtosis | -0.010963404 |
| Mean | 816827.81 |
| Median Absolute Deviation (MAD) | 4435 |
| Skewness | -1.2781954 |
| Sum | 1.5555293 × 1012 |
| Variance | 1.8088344 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 20000 | 119698 | 6.3% |
| 30000 | 118531 | 6.2% |
| 1064343 | 106285 | 5.6% |
| 989141 | 47298 | 2.5% |
| 1064456 | 42101 | 2.2% |
| 91000 | 23003 | 1.2% |
| 1062065 | 22769 | 1.2% |
| 71000 | 20903 | 1.1% |
| 920095 | 19501 | 1.0% |
| 905487 | 17529 | 0.9% |
| Other values (1006) | 1366736 |
| Value | Count | Frequency (%) |
| 5 | 24 | < 0.1% |
| 31 | 10148 | |
| 80 | 5689 | |
| 102 | 3550 | 0.2% |
| 145 | 7826 | |
| 161 | 6797 | |
| 315 | 9346 | |
| 412 | 13799 | |
| 811 | 4171 | 0.2% |
| 821 | 4342 | 0.2% |
| Value | Count | Frequency (%) |
| 9001793 | 2 | < 0.1% |
| 6009449 | 11 | < 0.1% |
| 2002989 | 1 | < 0.1% |
| 1065877 | 32 | < 0.1% |
| 1065866 | 103 | |
| 1065862 | 88 | |
| 1065860 | 15 | < 0.1% |
| 1065859 | 101 | |
| 1065855 | 4 | < 0.1% |
| 1065852 | 175 |
IORDEN
Real number (ℝ)
| Distinct | 927621 |
|---|---|
| Distinct (%) | 48.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 528961.8 |
| Minimum | 1 |
|---|---|
| Maximum | 1438187 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 45909.65 |
| Q1 | 279794 |
| median | 550309 |
| Q3 | 780838.75 |
| 95-th percentile | 956904 |
| Maximum | 1438187 |
| Range | 1438186 |
| Interquartile range (IQR) | 501044.75 |
Descriptive statistics
| Standard deviation | 290419.62 |
|---|---|
| Coefficient of variation (CV) | 0.54903705 |
| Kurtosis | -1.188255 |
| Mean | 528961.8 |
| Median Absolute Deviation (MAD) | 248728 |
| Skewness | -0.14691818 |
| Sum | 1.0073305 × 1012 |
| Variance | 8.4343558 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2 | 244 | < 0.1% |
| 3 | 238 | < 0.1% |
| 4 | 224 | < 0.1% |
| 9 | 211 | < 0.1% |
| 5 | 210 | < 0.1% |
| 7 | 207 | < 0.1% |
| 8 | 206 | < 0.1% |
| 10 | 196 | < 0.1% |
| 6 | 188 | < 0.1% |
| 13 | 180 | < 0.1% |
| Other values (927611) | 1902250 |
| Value | Count | Frequency (%) |
| 1 | 171 | |
| 2 | 244 | |
| 3 | 238 | |
| 4 | 224 | |
| 5 | 210 | |
| 6 | 188 | |
| 7 | 207 | |
| 8 | 206 | |
| 9 | 211 | |
| 10 | 196 |
| Value | Count | Frequency (%) |
| 1438187 | 1 | |
| 1437908 | 1 | |
| 1437814 | 1 | |
| 1437719 | 1 | |
| 1437717 | 1 | |
| 1437701 | 1 | |
| 1437685 | 1 | |
| 1437683 | 1 | |
| 1437655 | 1 | |
| 1437638 | 1 |
FOPER
Date
| Distinct | 5909 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 14.5 MiB |
| Minimum | 1993-09-09 00:00:00 |
|---|---|
| Maximum | 2024-11-29 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
AÑO_OPE
Real number (ℝ)
High correlation
| Distinct | 29 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2015.0524 |
| Minimum | 1993 |
|---|---|
| Maximum | 2024 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.6 MiB |
Quantile statistics
| Minimum | 1993 |
|---|---|
| 5-th percentile | 2004 |
| Q1 | 2011 |
| median | 2016 |
| Q3 | 2020 |
| 95-th percentile | 2024 |
| Maximum | 2024 |
| Range | 31 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 5.9695826 |
|---|---|
| Coefficient of variation (CV) | 0.002962495 |
| Kurtosis | -0.77563945 |
| Mean | 2015.0524 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | -0.36351655 |
| Sum | 3.837373 × 109 |
| Variance | 35.635916 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=29)
| Value | Count | Frequency (%) |
| 2016 | 118371 | 6.2% |
| 2024 | 113970 | 6.0% |
| 2018 | 111914 | 5.9% |
| 2017 | 110129 | 5.8% |
| 2020 | 109495 | 5.7% |
| 2019 | 107578 | 5.6% |
| 2023 | 106992 | 5.6% |
| 2015 | 100067 | 5.3% |
| 2021 | 98737 | 5.2% |
| 2022 | 98074 | 5.1% |
| Other values (19) | 829027 |
| Value | Count | Frequency (%) |
| 1993 | 10 | < 0.1% |
| 1994 | 29 | < 0.1% |
| 1998 | 5 | < 0.1% |
| 1999 | 20 | < 0.1% |
| 2000 | 132 | < 0.1% |
| 2001 | 170 | < 0.1% |
| 2002 | 39059 | |
| 2003 | 40678 | |
| 2004 | 37969 | |
| 2005 | 40782 |
| Value | Count | Frequency (%) |
| 2024 | 113970 | |
| 2023 | 106992 | |
| 2022 | 98074 | |
| 2021 | 98737 | |
| 2020 | 109495 | |
| 2019 | 107578 | |
| 2018 | 111914 | |
| 2017 | 110129 | |
| 2016 | 118371 | |
| 2015 | 100067 |
MES_OPE
Real number (ℝ)
High correlation
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.5188542 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.4059758 |
|---|---|
| Coefficient of variation (CV) | 0.52248076 |
| Kurtosis | -1.1815875 |
| Mean | 6.5188542 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.026526235 |
| Sum | 12414206 |
| Variance | 11.600671 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 10 | 170861 | |
| 8 | 169714 | |
| 7 | 166217 | |
| 5 | 163971 | |
| 6 | 162337 | |
| 1 | 160274 | |
| 9 | 157567 | |
| 3 | 157049 | |
| 4 | 152720 | |
| 11 | 152394 | |
| Other values (2) | 291250 |
| Value | Count | Frequency (%) |
| 1 | 160274 | |
| 2 | 144125 | |
| 3 | 157049 | |
| 4 | 152720 | |
| 5 | 163971 | |
| 6 | 162337 | |
| 7 | 166217 | |
| 8 | 169714 | |
| 9 | 157567 | |
| 10 | 170861 |
| Value | Count | Frequency (%) |
| 12 | 147125 | |
| 11 | 152394 | |
| 10 | 170861 | |
| 9 | 157567 | |
| 8 | 169714 | |
| 7 | 166217 | |
| 6 | 162337 | |
| 5 | 163971 | |
| 4 | 152720 | |
| 3 | 157049 |
DIA_OPE
Real number (ℝ)
High correlation
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.873441 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 30 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.783561 |
|---|---|
| Coefficient of variation (CV) | 0.55334952 |
| Kurtosis | -1.2002696 |
| Mean | 15.873441 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.007462111 |
| Sum | 30228651 |
| Variance | 77.150943 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=31)
| Value | Count | Frequency (%) |
| 8 | 65263 | 3.4% |
| 28 | 65202 | 3.4% |
| 13 | 65034 | 3.4% |
| 11 | 64957 | 3.4% |
| 14 | 64674 | 3.4% |
| 22 | 64627 | 3.4% |
| 27 | 64270 | 3.4% |
| 26 | 64228 | 3.4% |
| 23 | 63984 | 3.4% |
| 9 | 63817 | 3.4% |
| Other values (21) | 1258298 |
| Value | Count | Frequency (%) |
| 1 | 53275 | |
| 2 | 57544 | |
| 3 | 63319 | |
| 4 | 63328 | |
| 5 | 62194 | |
| 6 | 62329 | |
| 7 | 63775 | |
| 8 | 65263 | |
| 9 | 63817 | |
| 10 | 63425 |
| Value | Count | Frequency (%) |
| 31 | 38818 | |
| 30 | 60148 | |
| 29 | 59871 | |
| 28 | 65202 | |
| 27 | 64270 | |
| 26 | 64228 | |
| 25 | 59091 | |
| 24 | 62746 | |
| 23 | 63984 | |
| 22 | 64627 |
FLIQ
Categorical
High cardinality
| Distinct | 5913 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.8 MiB |
| 2002-02-28 00:00:00 | 1412 |
|---|---|
| 2024-06-13 00:00:00 | 659 |
| 2024-11-28 00:00:00 | 636 |
| 2016-09-08 00:00:00 | 611 |
| 2024-06-20 00:00:00 | 610 |
| Other values (5908) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Unique
| Unique | 69 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2020-11-12 00:00:00 |
|---|---|
| 2nd row | 2020-11-12 00:00:00 |
| 3rd row | 2020-11-12 00:00:00 |
| 4th row | 2020-11-12 00:00:00 |
| 5th row | 2020-04-01 00:00:00 |
Common Values
| Value | Count | Frequency (%) |
| 2002-02-28 00:00:00 | 1412 | 0.1% |
| 2024-06-13 00:00:00 | 659 | < 0.1% |
| 2024-11-28 00:00:00 | 636 | < 0.1% |
| 2016-09-08 00:00:00 | 611 | < 0.1% |
| 2024-06-20 00:00:00 | 610 | < 0.1% |
| 2018-12-13 00:00:00 | 605 | < 0.1% |
| 2024-01-11 00:00:00 | 597 | < 0.1% |
| 2017-01-26 00:00:00 | 597 | < 0.1% |
| 2016-07-21 00:00:00 | 593 | < 0.1% |
| 2024-11-22 00:00:00 | 587 | < 0.1% |
| Other values (5903) | 1897447 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 00:00:00 | 1904354 | |
| 2002-02-28 | 1412 | < 0.1% |
| 2024-06-13 | 659 | < 0.1% |
| 2024-11-28 | 636 | < 0.1% |
| 2016-09-08 | 611 | < 0.1% |
| 2024-06-20 | 610 | < 0.1% |
| 2018-12-13 | 605 | < 0.1% |
| 2024-01-11 | 597 | < 0.1% |
| 2017-01-26 | 597 | < 0.1% |
| 2016-07-21 | 593 | < 0.1% |
| Other values (5904) | 1898034 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 16233477 | |
| - | 3808708 | 10.5% |
| : | 3808708 | 10.5% |
| 2 | 3767885 | 10.4% |
| 1 | 2831166 | 7.8% |
| 1904354 | 5.3% | |
| 3 | 688744 | 1.9% |
| 4 | 585123 | 1.6% |
| 9 | 527009 | 1.5% |
| 8 | 523882 | 1.4% |
| Other values (3) | 1503670 | 4.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 36182726 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 16233477 | |
| - | 3808708 | 10.5% |
| : | 3808708 | 10.5% |
| 2 | 3767885 | 10.4% |
| 1 | 2831166 | 7.8% |
| 1904354 | 5.3% | |
| 3 | 688744 | 1.9% |
| 4 | 585123 | 1.6% |
| 9 | 527009 | 1.5% |
| 8 | 523882 | 1.4% |
| Other values (3) | 1503670 | 4.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 36182726 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 16233477 | |
| - | 3808708 | 10.5% |
| : | 3808708 | 10.5% |
| 2 | 3767885 | 10.4% |
| 1 | 2831166 | 7.8% |
| 1904354 | 5.3% | |
| 3 | 688744 | 1.9% |
| 4 | 585123 | 1.6% |
| 9 | 527009 | 1.5% |
| 8 | 523882 | 1.4% |
| Other values (3) | 1503670 | 4.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 36182726 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 16233477 | |
| - | 3808708 | 10.5% |
| : | 3808708 | 10.5% |
| 2 | 3767885 | 10.4% |
| 1 | 2831166 | 7.8% |
| 1904354 | 5.3% | |
| 3 | 688744 | 1.9% |
| 4 | 585123 | 1.6% |
| 9 | 527009 | 1.5% |
| 8 | 523882 | 1.4% |
| Other values (3) | 1503670 | 4.2% |
AÑO_FLIQ
Real number (ℝ)
High correlation
| Distinct | 29 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2015.0525 |
| Minimum | 1993 |
|---|---|
| Maximum | 2024 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.6 MiB |
Quantile statistics
| Minimum | 1993 |
|---|---|
| 5-th percentile | 2004 |
| Q1 | 2011 |
| median | 2016 |
| Q3 | 2020 |
| 95-th percentile | 2024 |
| Maximum | 2024 |
| Range | 31 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 5.9695696 |
|---|---|
| Coefficient of variation (CV) | 0.0029624884 |
| Kurtosis | -0.77569569 |
| Mean | 2015.0525 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | -0.36350039 |
| Sum | 3.8373733 × 109 |
| Variance | 35.635761 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=29)
| Value | Count | Frequency (%) |
| 2016 | 118364 | 6.2% |
| 2024 | 113986 | 6.0% |
| 2018 | 111928 | 5.9% |
| 2017 | 110154 | 5.8% |
| 2020 | 109487 | 5.7% |
| 2019 | 107567 | 5.6% |
| 2023 | 106998 | 5.6% |
| 2015 | 100034 | 5.3% |
| 2021 | 98754 | 5.2% |
| 2022 | 98057 | 5.1% |
| Other values (19) | 829025 |
| Value | Count | Frequency (%) |
| 1993 | 10 | < 0.1% |
| 1994 | 29 | < 0.1% |
| 1998 | 5 | < 0.1% |
| 1999 | 20 | < 0.1% |
| 2000 | 132 | < 0.1% |
| 2001 | 170 | < 0.1% |
| 2002 | 39033 | |
| 2003 | 40686 | |
| 2004 | 37986 | |
| 2005 | 40783 |
| Value | Count | Frequency (%) |
| 2024 | 113986 | |
| 2023 | 106998 | |
| 2022 | 98057 | |
| 2021 | 98754 | |
| 2020 | 109487 | |
| 2019 | 107567 | |
| 2018 | 111928 | |
| 2017 | 110154 | |
| 2016 | 118364 | |
| 2015 | 100034 |
MES_FLIQ
Real number (ℝ)
High correlation
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.5232084 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.4059616 |
|---|---|
| Coefficient of variation (CV) | 0.52212982 |
| Kurtosis | -1.1815418 |
| Mean | 6.5232084 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.026989512 |
| Sum | 12422498 |
| Variance | 11.600574 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 10 | 170593 | |
| 8 | 169585 | |
| 7 | 166485 | |
| 5 | 163869 | |
| 6 | 162310 | |
| 1 | 159437 | |
| 9 | 157550 | |
| 3 | 156928 | |
| 4 | 152766 | |
| 11 | 152739 | |
| Other values (2) | 292092 |
| Value | Count | Frequency (%) |
| 1 | 159437 | |
| 2 | 144318 | |
| 3 | 156928 | |
| 4 | 152766 | |
| 5 | 163869 | |
| 6 | 162310 | |
| 7 | 166485 | |
| 8 | 169585 | |
| 9 | 157550 | |
| 10 | 170593 |
| Value | Count | Frequency (%) |
| 12 | 147774 | |
| 11 | 152739 | |
| 10 | 170593 | |
| 9 | 157550 | |
| 8 | 169585 | |
| 7 | 166485 | |
| 6 | 162310 | |
| 5 | 163869 | |
| 4 | 152766 | |
| 3 | 156928 |
DIA_FLIQ
Real number (ℝ)
High correlation
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.892825 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 30 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.7822635 |
|---|---|
| Coefficient of variation (CV) | 0.552593 |
| Kurtosis | -1.1989264 |
| Mean | 15.892825 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.0052201311 |
| Sum | 30265564 |
| Variance | 77.128153 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=31)
| Value | Count | Frequency (%) |
| 8 | 65398 | 3.4% |
| 26 | 65042 | 3.4% |
| 11 | 65026 | 3.4% |
| 13 | 64838 | 3.4% |
| 28 | 64834 | 3.4% |
| 14 | 64756 | 3.4% |
| 22 | 64679 | 3.4% |
| 27 | 64399 | 3.4% |
| 15 | 64186 | 3.4% |
| 9 | 64081 | 3.4% |
| Other values (21) | 1257115 |
| Value | Count | Frequency (%) |
| 1 | 53222 | |
| 2 | 57634 | |
| 3 | 62587 | |
| 4 | 63325 | |
| 5 | 61832 | |
| 6 | 61444 | |
| 7 | 63414 | |
| 8 | 65398 | |
| 9 | 64081 | |
| 10 | 63650 |
| Value | Count | Frequency (%) |
| 31 | 39155 | |
| 30 | 60377 | |
| 29 | 60210 | |
| 28 | 64834 | |
| 27 | 64399 | |
| 26 | 65042 | |
| 25 | 59005 | |
| 24 | 62484 | |
| 23 | 63996 | |
| 22 | 64679 |
CPZO_DE
Real number (ℝ)
High correlation Skewed
| Distinct | 8786 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 419.01227 |
| Minimum | 0 |
|---|---|
| Maximum | 999999 |
| Zeros | 12 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 3 |
| 95-th percentile | 3016 |
| Maximum | 999999 |
| Range | 999999 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 3360.996 |
|---|---|
| Coefficient of variation (CV) | 8.0212353 |
| Kurtosis | 69950.06 |
| Mean | 419.01227 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 236.54025 |
| Sum | 7.9794769 × 108 |
| Variance | 11296294 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 1148376 | |
| 3 | 275439 | 14.5% |
| 4 | 36264 | 1.9% |
| 28 | 28280 | 1.5% |
| 7 | 21067 | 1.1% |
| 2 | 18169 | 1.0% |
| 5 | 9123 | 0.5% |
| 14 | 5475 | 0.3% |
| 91 | 4587 | 0.2% |
| 6 | 4455 | 0.2% |
| Other values (8776) | 353119 | 18.5% |
| Value | Count | Frequency (%) |
| 0 | 12 | < 0.1% |
| 1 | 1148376 | |
| 2 | 18169 | 1.0% |
| 3 | 275439 | 14.5% |
| 4 | 36264 | 1.9% |
| 5 | 9123 | 0.5% |
| 6 | 4455 | 0.2% |
| 7 | 21067 | 1.1% |
| 8 | 2687 | 0.1% |
| 9 | 1467 | 0.1% |
| Value | Count | Frequency (%) |
| 999999 | 2 | |
| 999996 | 2 | |
| 999988 | 2 | |
| 999986 | 1 | < 0.1% |
| 999925 | 1 | < 0.1% |
| 999917 | 1 | < 0.1% |
| 999910 | 1 | < 0.1% |
| 999883 | 1 | < 0.1% |
| 999772 | 1 | < 0.1% |
| 999757 | 4 |
CPZO_A
Real number (ℝ)
High correlation Skewed
| Distinct | 8796 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 420.45603 |
| Minimum | 0 |
|---|---|
| Maximum | 999999 |
| Zeros | 12 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 3 |
| 95-th percentile | 3020 |
| Maximum | 999999 |
| Range | 999999 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 3368.9011 |
|---|---|
| Coefficient of variation (CV) | 8.0124932 |
| Kurtosis | 69299.013 |
| Mean | 420.45603 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 235.00232 |
| Sum | 8.0069712 × 108 |
| Variance | 11349495 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 1148123 | |
| 3 | 275438 | 14.5% |
| 4 | 36264 | 1.9% |
| 28 | 28282 | 1.5% |
| 7 | 21069 | 1.1% |
| 2 | 18170 | 1.0% |
| 5 | 9123 | 0.5% |
| 14 | 5474 | 0.3% |
| 91 | 4774 | 0.3% |
| 6 | 4455 | 0.2% |
| Other values (8786) | 353182 | 18.5% |
| Value | Count | Frequency (%) |
| 0 | 12 | < 0.1% |
| 1 | 1148123 | |
| 2 | 18170 | 1.0% |
| 3 | 275438 | 14.5% |
| 4 | 36264 | 1.9% |
| 5 | 9123 | 0.5% |
| 6 | 4455 | 0.2% |
| 7 | 21069 | 1.1% |
| 8 | 2687 | 0.1% |
| 9 | 1467 | 0.1% |
| Value | Count | Frequency (%) |
| 999999 | 2 | |
| 999996 | 2 | |
| 999988 | 2 | |
| 999986 | 1 | < 0.1% |
| 999925 | 1 | < 0.1% |
| 999917 | 1 | < 0.1% |
| 999910 | 1 | < 0.1% |
| 999883 | 1 | < 0.1% |
| 999772 | 1 | < 0.1% |
| 999757 | 4 |
PLAZOREF
Real number (ℝ)
Skewed Zeros
| Distinct | 47 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.4694469 |
| Minimum | 0 |
|---|---|
| Maximum | 3612 |
| Zeros | 1837810 |
| Zeros (%) | 96.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 3612 |
| Range | 3612 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 16.482166 |
|---|---|
| Coefficient of variation (CV) | 11.216579 |
| Kurtosis | 8881.6522 |
| Mean | 1.4694469 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 51.328521 |
| Sum | 2798347 |
| Variance | 271.66181 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=47)
| Value | Count | Frequency (%) |
| 0 | 1837810 | |
| 1 | 40721 | 2.1% |
| 182 | 9571 | 0.5% |
| 28 | 8112 | 0.4% |
| 91 | 7892 | 0.4% |
| 30 | 170 | < 0.1% |
| 31 | 16 | < 0.1% |
| 27 | 4 | < 0.1% |
| 183 | 3 | < 0.1% |
| 1456 | 3 | < 0.1% |
| Other values (37) | 52 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 1837810 | |
| 1 | 40721 | 2.1% |
| 25 | 2 | < 0.1% |
| 27 | 4 | < 0.1% |
| 28 | 8112 | 0.4% |
| 29 | 3 | < 0.1% |
| 30 | 170 | < 0.1% |
| 31 | 16 | < 0.1% |
| 33 | 1 | < 0.1% |
| 91 | 7892 | 0.4% |
| Value | Count | Frequency (%) |
| 3612 | 2 | |
| 3605 | 2 | |
| 3598 | 2 | |
| 3591 | 1 | < 0.1% |
| 1456 | 3 | |
| 1445 | 2 | |
| 1410 | 2 | |
| 1409 | 2 | |
| 1291 | 2 | |
| 1096 | 2 |
FVENCE
Date
| Distinct | 6154 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 27 |
| Missing (%) | < 0.1% |
| Memory size | 14.5 MiB |
| Minimum | 2002-02-22 00:00:00 |
|---|---|
| Maximum | 2054-10-29 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
AÑO_FVENCE
Real number (ℝ)
High correlation Skewed
| Distinct | 55 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2016.1879 |
| Minimum | 2002 |
|---|---|
| Maximum | 4743 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.6 MiB |
Quantile statistics
| Minimum | 2002 |
|---|---|
| 5-th percentile | 2004 |
| Q1 | 2011 |
| median | 2016 |
| Q3 | 2021 |
| 95-th percentile | 2026 |
| Maximum | 4743 |
| Range | 2741 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 11.099629 |
|---|---|
| Coefficient of variation (CV) | 0.0055052552 |
| Kurtosis | 32579.44 |
| Mean | 2016.1879 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 133.376 |
| Sum | 3.8395355 × 109 |
| Variance | 123.20176 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2024 | 116596 | 6.1% |
| 2016 | 111666 | 5.9% |
| 2020 | 106864 | 5.6% |
| 2018 | 105796 | 5.6% |
| 2019 | 101529 | 5.3% |
| 2017 | 100515 | 5.3% |
| 2015 | 95020 | 5.0% |
| 2011 | 94356 | 5.0% |
| 2023 | 92184 | 4.8% |
| 2012 | 91973 | 4.8% |
| Other values (45) | 887855 |
| Value | Count | Frequency (%) |
| 2002 | 30608 | 1.6% |
| 2003 | 37320 | 2.0% |
| 2004 | 37720 | 2.0% |
| 2005 | 39186 | |
| 2006 | 39002 | |
| 2007 | 42266 | |
| 2008 | 50854 | |
| 2009 | 73040 | |
| 2010 | 76204 | |
| 2011 | 94356 |
| Value | Count | Frequency (%) |
| 4743 | 17 | < 0.1% |
| 2999 | 2 | < 0.1% |
| 2282 | 3 | < 0.1% |
| 2278 | 4 | < 0.1% |
| 2277 | 1 | < 0.1% |
| 2054 | 185 | < 0.1% |
| 2053 | 2826 | |
| 2051 | 8 | < 0.1% |
| 2050 | 2782 | |
| 2047 | 6626 |
MES_FVENCE
Real number (ℝ)
High correlation
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.7017739 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.4686622 |
|---|---|
| Coefficient of variation (CV) | 0.51757374 |
| Kurtosis | -1.2026459 |
| Mean | 6.7017739 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.069282275 |
| Sum | 12762550 |
| Variance | 12.031618 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 11 | 184221 | |
| 12 | 177352 | |
| 7 | 168007 | |
| 6 | 164169 | |
| 5 | 162557 | |
| 1 | 159003 | |
| 10 | 158948 | |
| 8 | 154410 | |
| 3 | 153205 | |
| 9 | 152267 | |
| Other values (2) | 270215 |
| Value | Count | Frequency (%) |
| 1 | 159003 | |
| 2 | 130297 | |
| 3 | 153205 | |
| 4 | 139918 | |
| 5 | 162557 | |
| 6 | 164169 | |
| 7 | 168007 | |
| 8 | 154410 | |
| 9 | 152267 | |
| 10 | 158948 |
| Value | Count | Frequency (%) |
| 12 | 177352 | |
| 11 | 184221 | |
| 10 | 158948 | |
| 9 | 152267 | |
| 8 | 154410 | |
| 7 | 168007 | |
| 6 | 164169 | |
| 5 | 162557 | |
| 4 | 139918 | |
| 3 | 153205 |
DIA_FVENCE
Real number (ℝ)
High correlation
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.73511 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 30 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.8171836 |
|---|---|
| Coefficient of variation (CV) | 0.56035093 |
| Kurtosis | -1.2087605 |
| Mean | 15.73511 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.040999184 |
| Sum | 29965220 |
| Variance | 77.742726 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=31)
| Value | Count | Frequency (%) |
| 5 | 83035 | 4.4% |
| 22 | 70880 | 3.7% |
| 9 | 69666 | 3.7% |
| 7 | 68909 | 3.6% |
| 3 | 68159 | 3.6% |
| 13 | 66982 | 3.5% |
| 16 | 65224 | 3.4% |
| 17 | 63751 | 3.3% |
| 14 | 63441 | 3.3% |
| 23 | 63391 | 3.3% |
| Other values (21) | 1220916 |
| Value | Count | Frequency (%) |
| 1 | 50260 | |
| 2 | 54847 | |
| 3 | 68159 | |
| 4 | 61839 | |
| 5 | 83035 | |
| 6 | 59392 | |
| 7 | 68909 | |
| 8 | 61042 | |
| 9 | 69666 | |
| 10 | 60704 |
| Value | Count | Frequency (%) |
| 31 | 42775 | |
| 30 | 60176 | |
| 29 | 62175 | |
| 28 | 59697 | |
| 27 | 62056 | |
| 26 | 62561 | |
| 25 | 54934 | |
| 24 | 58811 | |
| 23 | 63391 | |
| 22 | 70880 |
IINSTR
Categorical
High cardinality Imbalance
| Distinct | 132 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.6 MiB |
| PAGNAFIN | |
|---|---|
| BONOS | 97511 |
| CETESI | 78124 |
| CBIC | 58118 |
| Other values (127) |
Length
| Max length | 15 |
|---|---|
| Median length | 1 |
| Mean length | 3.4426031 |
| Min length | 1 |
Unique
| Unique | 6 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | DEPBANX2 |
|---|---|
| 2nd row | DEPBANX2 |
| 3rd row | DEPBANX2 |
| 4th row | DEPBANX2 |
| 5th row | DEPBANX2 |
Common Values
| Value | Count | Frequency (%) |
| 1108611 | ||
| PAGNAFIN | 377164 | 19.8% |
| BONOS | 97511 | 5.1% |
| CETESI | 78124 | 4.1% |
| CBIC | 58118 | 3.1% |
| UDIBONO | 41263 | 2.2% |
| PAGARE | 25632 | 1.3% |
| BPA182 | 22649 | 1.2% |
| BONDESD | 22555 | 1.2% |
| BONDESF | 9015 | 0.5% |
| Other values (122) | 63712 | 3.3% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| pagnafin | 377164 | |
| bonos | 97511 | 12.3% |
| cetesi | 78124 | 9.8% |
| cbic | 58118 | 7.3% |
| udibono | 41263 | 5.2% |
| pagare | 25632 | 3.2% |
| bpa182 | 22649 | 2.9% |
| bondesd | 22555 | 2.8% |
| bondesf | 9015 | 1.1% |
| cerburudi | 7774 | 1.0% |
| Other values (122) | 53723 | 6.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1126619 | ||
| N | 931943 | |
| A | 852545 | |
| I | 569698 | |
| P | 450965 | |
| G | 416907 | 6.4% |
| F | 388503 | 5.9% |
| O | 316622 | 4.8% |
| B | 308759 | 4.7% |
| E | 259713 | 4.0% |
| Other values (24) | 933661 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6555935 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1126619 | ||
| N | 931943 | |
| A | 852545 | |
| I | 569698 | |
| P | 450965 | |
| G | 416907 | 6.4% |
| F | 388503 | 5.9% |
| O | 316622 | 4.8% |
| B | 308759 | 4.7% |
| E | 259713 | 4.0% |
| Other values (24) | 933661 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6555935 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1126619 | ||
| N | 931943 | |
| A | 852545 | |
| I | 569698 | |
| P | 450965 | |
| G | 416907 | 6.4% |
| F | 388503 | 5.9% |
| O | 316622 | 4.8% |
| B | 308759 | 4.7% |
| E | 259713 | 4.0% |
| Other values (24) | 933661 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6555935 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1126619 | ||
| N | 931943 | |
| A | 852545 | |
| I | 569698 | |
| P | 450965 | |
| G | 416907 | 6.4% |
| F | 388503 | 5.9% |
| O | 316622 | 4.8% |
| B | 308759 | 4.7% |
| E | 259713 | 4.0% |
| Other values (24) | 933661 |
ITINSTR
Categorical
High correlation Imbalance
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| GUBERR | |
|---|---|
| BANCAR | |
| OTROSRET | 61293 |
| GUBER | 14948 |
| OTROS | 782 |
| Other values (8) | 77 |
Length
| Max length | 9 |
|---|---|
| Median length | 6 |
| Mean length | 6.0561718 |
| Min length | 5 |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | OTROS |
|---|---|
| 2nd row | OTROS |
| 3rd row | OTROS |
| 4th row | OTROS |
| 5th row | OTROS |
Common Values
| Value | Count | Frequency (%) |
| GUBERR | 1407349 | |
| BANCAR | 419905 | 22.0% |
| OTROSRET | 61293 | 3.2% |
| GUBER | 14948 | 0.8% |
| OTROS | 782 | < 0.1% |
| BANCARUS | 53 | < 0.1% |
| ICUSA | 6 | < 0.1% |
| PRIVADO | 6 | < 0.1% |
| GAMEXB | 5 | < 0.1% |
| GUBERN | 4 | < 0.1% |
| Other values (3) | 3 | < 0.1% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| guberr | 1407349 | |
| bancar | 419905 | 22.0% |
| otrosret | 61293 | 3.2% |
| guber | 14948 | 0.8% |
| otros | 782 | < 0.1% |
| bancarus | 53 | < 0.1% |
| icusa | 6 | < 0.1% |
| privado | 6 | < 0.1% |
| gamexb | 5 | < 0.1% |
| gubern | 4 | < 0.1% |
| Other values (3) | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 3372986 | |
| B | 1842266 | |
| E | 1483599 | |
| U | 1422360 | |
| G | 1422306 | |
| A | 839936 | 7.3% |
| N | 419966 | 3.6% |
| C | 419966 | 3.6% |
| O | 124160 | 1.1% |
| T | 123371 | 1.1% |
| Other values (8) | 62179 | 0.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 11533095 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| R | 3372986 | |
| B | 1842266 | |
| E | 1483599 | |
| U | 1422360 | |
| G | 1422306 | |
| A | 839936 | 7.3% |
| N | 419966 | 3.6% |
| C | 419966 | 3.6% |
| O | 124160 | 1.1% |
| T | 123371 | 1.1% |
| Other values (8) | 62179 | 0.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 11533095 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| R | 3372986 | |
| B | 1842266 | |
| E | 1483599 | |
| U | 1422360 | |
| G | 1422306 | |
| A | 839936 | 7.3% |
| N | 419966 | 3.6% |
| C | 419966 | 3.6% |
| O | 124160 | 1.1% |
| T | 123371 | 1.1% |
| Other values (8) | 62179 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 11533095 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| R | 3372986 | |
| B | 1842266 | |
| E | 1483599 | |
| U | 1422360 | |
| G | 1422306 | |
| A | 839936 | 7.3% |
| N | 419966 | 3.6% |
| C | 419966 | 3.6% |
| O | 124160 | 1.1% |
| T | 123371 | 1.1% |
| Other values (8) | 62179 | 0.5% |
NTINSTR
Categorical
High correlation Imbalance
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| PAPEL GUBERNAMENTAL | |
|---|---|
| PAPELES BANCARIOS EN GRAL | |
| Instrumentos con retenci� | 61293 |
| Otros Instrumentos | 782 |
| PAPEL BANCARIO USD | 53 |
| Other values (5) | 19 |
Length
| Max length | 25 |
|---|---|
| Median length | 19 |
| Mean length | 20.515649 |
| Min length | 7 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Otros Instrumentos |
|---|---|
| 2nd row | Otros Instrumentos |
| 3rd row | Otros Instrumentos |
| 4th row | Otros Instrumentos |
| 5th row | Otros Instrumentos |
Common Values
| Value | Count | Frequency (%) |
| PAPEL GUBERNAMENTAL | 1422301 | |
| PAPELES BANCARIOS EN GRAL | 419906 | 22.0% |
| Instrumentos con retenci� | 61293 | 3.2% |
| Otros Instrumentos | 782 | < 0.1% |
| PAPEL BANCARIO USD | 53 | < 0.1% |
| PAPEL COMERCIAL ICUSA | 6 | < 0.1% |
| PRIVADO | 6 | < 0.1% |
| ABS AMERICAN EXPRESS BANK | 5 | < 0.1% |
| Instrumentos con man fisc | 1 | < 0.1% |
| Otros Insrumentos | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| papel | 1422360 | |
| gubernamental | 1422301 | |
| papeles | 419906 | 8.9% |
| bancarios | 419906 | 8.9% |
| en | 419906 | 8.9% |
| gral | 419906 | 8.9% |
| instrumentos | 62076 | 1.3% |
| con | 61294 | 1.3% |
| retenci� | 61293 | 1.3% |
| otros | 783 | < 0.1% |
| Other values (12) | 147 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 5946730 | |
| E | 5526701 | |
| P | 3684543 | |
| L | 3684479 | |
| N | 3684477 | |
| 2805524 | ||
| R | 2262188 | 5.8% |
| B | 1842270 | 4.7% |
| G | 1842207 | 4.7% |
| U | 1422360 | 3.6% |
| Other values (23) | 6367580 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 39069059 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 5946730 | |
| E | 5526701 | |
| P | 3684543 | |
| L | 3684479 | |
| N | 3684477 | |
| 2805524 | ||
| R | 2262188 | 5.8% |
| B | 1842270 | 4.7% |
| G | 1842207 | 4.7% |
| U | 1422360 | 3.6% |
| Other values (23) | 6367580 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 39069059 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 5946730 | |
| E | 5526701 | |
| P | 3684543 | |
| L | 3684479 | |
| N | 3684477 | |
| 2805524 | ||
| R | 2262188 | 5.8% |
| B | 1842270 | 4.7% |
| G | 1842207 | 4.7% |
| U | 1422360 | 3.6% |
| Other values (23) | 6367580 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 39069059 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 5946730 | |
| E | 5526701 | |
| P | 3684543 | |
| L | 3684479 | |
| N | 3684477 | |
| 2805524 | ||
| R | 2262188 | 5.8% |
| B | 1842270 | 4.7% |
| G | 1842207 | 4.7% |
| U | 1422360 | 3.6% |
| Other values (23) | 6367580 |
TASA
Real number (ℝ)
Skewed Zeros
| Distinct | 51965 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.1421575 |
| Minimum | -99.251541 |
|---|---|
| Maximum | 999 |
| Zeros | 55531 |
| Zeros (%) | 2.9% |
| Negative | 203 |
| Negative (%) | < 0.1% |
| Memory size | 7.3 MiB |
Quantile statistics
| Minimum | -99.251541 |
|---|---|
| 5-th percentile | 2.98 |
| Q1 | 4.2600002 |
| median | 5.75 |
| Q3 | 7.7800002 |
| 95-th percentile | 11.157175 |
| Maximum | 999 |
| Range | 1098.2516 |
| Interquartile range (IQR) | 3.52 |
Descriptive statistics
| Standard deviation | 4.7912083 |
|---|---|
| Coefficient of variation (CV) | 0.78005298 |
| Kurtosis | 18134.322 |
| Mean | 6.1421575 |
| Median Absolute Deviation (MAD) | 1.75 |
| Skewness | 104.61774 |
| Sum | 11696842 |
| Variance | 22.955675 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 55531 | 2.9% |
| 4.5 | 32327 | 1.7% |
| 4.480000019 | 26860 | 1.4% |
| 4.489999771 | 25477 | 1.3% |
| 7 | 18947 | 1.0% |
| 4.550000191 | 18472 | 1.0% |
| 4.46999979 | 18187 | 1.0% |
| 4 | 16143 | 0.8% |
| 4.519999981 | 15241 | 0.8% |
| 7.5 | 14110 | 0.7% |
| Other values (51955) | 1663059 |
| Value | Count | Frequency (%) |
| -99.25154114 | 4 | |
| -9.854305267 | 1 | < 0.1% |
| -9.722984314 | 2 | |
| -9.660676003 | 1 | < 0.1% |
| -9.607212067 | 1 | < 0.1% |
| -5.959506989 | 1 | < 0.1% |
| -4.300000191 | 1 | < 0.1% |
| -3.5 | 1 | < 0.1% |
| -3.349999905 | 1 | < 0.1% |
| -3.339999914 | 2 |
| Value | Count | Frequency (%) |
| 999 | 2 | |
| 935 | 2 | |
| 931 | 2 | |
| 927 | 2 | |
| 926 | 2 | |
| 923 | 2 | |
| 905 | 2 | |
| 893 | 2 | |
| 875 | 2 | |
| 860 | 2 |
MONEDA
Categorical
High correlation Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| MXP | |
|---|---|
| USD | 53 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MXP |
|---|---|
| 2nd row | MXP |
| 3rd row | MXP |
| 4th row | MXP |
| 5th row | MXP |
Common Values
| Value | Count | Frequency (%) |
| MXP | 1904301 | |
| USD | 53 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| mxp | 1904301 | |
| usd | 53 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| M | 1904301 | |
| X | 1904301 | |
| P | 1904301 | |
| U | 53 | < 0.1% |
| S | 53 | < 0.1% |
| D | 53 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5713062 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| M | 1904301 | |
| X | 1904301 | |
| P | 1904301 | |
| U | 53 | < 0.1% |
| S | 53 | < 0.1% |
| D | 53 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5713062 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| M | 1904301 | |
| X | 1904301 | |
| P | 1904301 | |
| U | 53 | < 0.1% |
| S | 53 | < 0.1% |
| D | 53 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5713062 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| M | 1904301 | |
| X | 1904301 | |
| P | 1904301 | |
| U | 53 | < 0.1% |
| S | 53 | < 0.1% |
| D | 53 | < 0.1% |
MONTO
Real number (ℝ)
High correlation Skewed
| Distinct | 1185442 |
|---|---|
| Distinct (%) | 62.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.0257022 × 108 |
| Minimum | 0 |
|---|---|
| Maximum | 1.5641229 × 1012 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 69230.9 |
| Q1 | 8348277.5 |
| median | 95858232 |
| Q3 | 7 × 108 |
| 95-th percentile | 5 × 109 |
| Maximum | 1.5641229 × 1012 |
| Range | 1.5641229 × 1012 |
| Interquartile range (IQR) | 6.9165172 × 108 |
Descriptive statistics
| Standard deviation | 3.2359094 × 109 |
|---|---|
| Coefficient of variation (CV) | 3.5852162 |
| Kurtosis | inf |
| Mean | 9.0257022 × 108 |
| Median Absolute Deviation (MAD) | 95333456 |
| Skewness | 133.80548 |
| Sum | 1.7188132 × 1015 |
| Variance | 1.047111 × 1019 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 5000000000 | 40313 | 2.1% |
| 2000000000 | 27701 | 1.5% |
| 1000000000 | 25666 | 1.3% |
| 999999936 | 22950 | 1.2% |
| 3000000000 | 18497 | 1.0% |
| 500000000 | 14904 | 0.8% |
| 1999999872 | 11370 | 0.6% |
| 2500000000 | 10936 | 0.6% |
| 1500000000 | 10276 | 0.5% |
| 4000000000 | 10272 | 0.5% |
| Other values (1185432) | 1711469 |
| Value | Count | Frequency (%) |
| 0 | 3 | |
| 0.009999999776 | 3 | |
| 0.01999999955 | 6 | |
| 0.1000000015 | 1 | < 0.1% |
| 0.5699999928 | 1 | < 0.1% |
| 0.7699999809 | 1 | < 0.1% |
| 0.8643058538 | 1 | < 0.1% |
| 0.8650169969 | 2 | < 0.1% |
| 0.8652539849 | 2 | < 0.1% |
| 0.865490973 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 1.564122939 × 1012 | 1 | < 0.1% |
| 9.999999959 × 1011 | 3 | |
| 6.500000072 × 1011 | 2 | |
| 5.999999713 × 1011 | 1 | < 0.1% |
| 4.99999998 × 1011 | 1 | < 0.1% |
| 4.365649838 × 1011 | 2 | |
| 4.337648599 × 1011 | 1 | < 0.1% |
| 4.013876838 × 1011 | 2 | |
| 4.000000573 × 1011 | 2 | |
| 3.231570985 × 1011 | 1 | < 0.1% |
MONTO_ASIGNADO
Real number (ℝ)
High correlation Zeros
| Distinct | 1188270 |
|---|---|
| Distinct (%) | 62.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.7885802 × 108 |
| Minimum | -13579079 |
|---|---|
| Maximum | 1.4667758 × 1011 |
| Zeros | 28357 |
| Zeros (%) | 1.5% |
| Negative | 2 |
| Negative (%) | < 0.1% |
| Memory size | 7.3 MiB |
Quantile statistics
| Minimum | -13579079 |
|---|---|
| 5-th percentile | 17244.902 |
| Q1 | 7041167.4 |
| median | 89004636 |
| Q3 | 6.7887302 × 108 |
| 95-th percentile | 5 × 109 |
| Maximum | 1.4667758 × 1011 |
| Range | 1.4669116 × 1011 |
| Interquartile range (IQR) | 6.7183186 × 108 |
Descriptive statistics
| Standard deviation | 2.4079949 × 109 |
|---|---|
| Coefficient of variation (CV) | 2.7399134 |
| Kurtosis | inf |
| Mean | 8.7885802 × 108 |
| Median Absolute Deviation (MAD) | 88721304 |
| Skewness | 11.049052 |
| Sum | 1.6736568 × 1015 |
| Variance | 5.7984395 × 1018 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 5000000000 | 39507 | 2.1% |
| 0 | 28357 | 1.5% |
| 2000000000 | 26842 | 1.4% |
| 1000000000 | 24188 | 1.3% |
| 999999936 | 23038 | 1.2% |
| 3000000000 | 18055 | 0.9% |
| 500000000 | 13363 | 0.7% |
| 1999999872 | 11420 | 0.6% |
| 2500000000 | 10640 | 0.6% |
| 4000000000 | 10047 | 0.5% |
| Other values (1188260) | 1698897 |
| Value | Count | Frequency (%) |
| -13579079 | 1 | < 0.1% |
| -400016.4688 | 1 | < 0.1% |
| 0 | 28357 | |
| 0.7384160161 | 1 | < 0.1% |
| 0.7411739826 | 1 | < 0.1% |
| 0.7855070233 | 1 | < 0.1% |
| 0.8035119772 | 1 | < 0.1% |
| 0.8052319884 | 1 | < 0.1% |
| 0.8069210052 | 1 | < 0.1% |
| 0.8101329803 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1.466775798 × 1011 | 1 | |
| 1.453221478 × 1011 | 1 | |
| 1.392402596 × 1011 | 1 | |
| 1.333044593 × 1011 | 1 | |
| 1.32204503 × 1011 | 1 | |
| 1.320375173 × 1011 | 1 | |
| 1.301427323 × 1011 | 1 | |
| 1.301411103 × 1011 | 1 | |
| 1.293893304 × 1011 | 1 | |
| 1.274216448 × 1011 | 1 |
MONTO_REAL
Real number (ℝ)
High correlation Skewed
| Distinct | 1186581 |
|---|---|
| Distinct (%) | 62.3% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.0237322 × 108 |
| Minimum | 0 |
|---|---|
| Maximum | 1.0031718 × 1012 |
| Zeros | 4 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 69254.684 |
| Q1 | 8360782.5 |
| median | 95924536 |
| Q3 | 7 × 108 |
| 95-th percentile | 5 × 109 |
| Maximum | 1.0031718 × 1012 |
| Range | 1.0031718 × 1012 |
| Interquartile range (IQR) | 6.9163922 × 108 |
Descriptive statistics
| Standard deviation | 3.0857713 × 109 |
|---|---|
| Coefficient of variation (CV) | 3.4196175 |
| Kurtosis | inf |
| Mean | 9.0237322 × 108 |
| Median Absolute Deviation (MAD) | 95399480 |
| Skewness | 94.710037 |
| Sum | 1.7184353 × 1015 |
| Variance | 9.521984 × 1018 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 5000000000 | 40294 | 2.1% |
| 2000000000 | 27682 | 1.5% |
| 1000000000 | 25608 | 1.3% |
| 999999936 | 22950 | 1.2% |
| 3000000000 | 18485 | 1.0% |
| 500000000 | 14762 | 0.8% |
| 1999999872 | 11371 | 0.6% |
| 2500000000 | 10933 | 0.6% |
| 4000000000 | 10268 | 0.5% |
| 1500000000 | 10256 | 0.5% |
| Other values (1186571) | 1711742 |
| Value | Count | Frequency (%) |
| 0 | 4 | |
| 0.009999999776 | 3 | |
| 0.01999999955 | 6 | |
| 0.1000000015 | 1 | < 0.1% |
| 0.5699999928 | 1 | < 0.1% |
| 0.6271209717 | 1 | < 0.1% |
| 0.7699999809 | 1 | < 0.1% |
| 0.8643058538 | 1 | < 0.1% |
| 0.8650169969 | 2 | < 0.1% |
| 0.8652539849 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 1.003171807 × 1012 | 1 | |
| 9.999999959 × 1011 | 2 | |
| 7.804609495 × 1011 | 1 | |
| 6.500000072 × 1011 | 2 | |
| 5.999999713 × 1011 | 1 | |
| 4.99999998 × 1011 | 1 | |
| 4.365649838 × 1011 | 2 | |
| 4.337275372 × 1011 | 1 | |
| 4.013876838 × 1011 | 2 | |
| 4.000000573 × 1011 | 2 |
FECHA_REGISTRO
Date
| Distinct | 5742 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 14.5 MiB |
| Minimum | 2002-01-21 00:00:00 |
|---|---|
| Maximum | 2024-11-29 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
Interactions
Correlations
| AÑO_FLIQ | AÑO_FVENCE | AÑO_OPE | CPZO_A | CPZO_DE | DIA_FLIQ | DIA_FVENCE | DIA_OPE | ESPROVEED | ICONTRATO | IORDEN | ITINSTR | MES_FLIQ | MES_FVENCE | MES_OPE | MONEDA | MONTO | MONTO_ASIGNADO | MONTO_REAL | NTINSTR | NUMERO_CLIENTE | PLAZOREF | TASA | TIPO_PERSONA | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AÑO_FLIQ | 1.000 | 0.930 | 1.000 | 0.037 | 0.037 | 0.002 | -0.004 | -0.002 | 0.116 | 0.350 | 0.034 | 0.222 | -0.027 | -0.017 | -0.027 | 0.010 | -0.102 | -0.101 | -0.102 | 0.086 | 0.350 | 0.056 | 0.290 | 0.097 |
| AÑO_FVENCE | 0.930 | 1.000 | 0.930 | 0.224 | 0.224 | 0.003 | -0.028 | 0.000 | 0.003 | 0.297 | 0.019 | 0.042 | -0.021 | 0.031 | -0.022 | 0.000 | -0.141 | -0.138 | -0.140 | 0.042 | 0.297 | 0.098 | 0.255 | 0.000 |
| AÑO_OPE | 1.000 | 0.930 | 1.000 | 0.037 | 0.037 | 0.002 | -0.004 | -0.002 | 0.116 | 0.350 | 0.034 | 0.222 | -0.027 | -0.017 | -0.027 | 0.010 | -0.102 | -0.101 | -0.102 | 0.086 | 0.350 | 0.056 | 0.290 | 0.097 |
| CPZO_A | 0.037 | 0.224 | 0.037 | 1.000 | 1.000 | 0.006 | -0.031 | 0.003 | 0.002 | -0.068 | 0.032 | 0.037 | 0.002 | 0.089 | -0.000 | 0.000 | -0.219 | -0.215 | -0.218 | 0.038 | -0.068 | 0.296 | 0.048 | 0.000 |
| CPZO_DE | 0.037 | 0.224 | 0.037 | 1.000 | 1.000 | 0.006 | -0.031 | 0.003 | 0.002 | -0.068 | 0.032 | 0.037 | 0.002 | 0.089 | -0.000 | 0.000 | -0.219 | -0.215 | -0.218 | 0.038 | -0.068 | 0.296 | 0.048 | 0.000 |
| DIA_FLIQ | 0.002 | 0.003 | 0.002 | 0.006 | 0.006 | 1.000 | 0.567 | 0.968 | 0.004 | 0.000 | 0.006 | 0.005 | -0.005 | -0.002 | -0.003 | 0.004 | -0.005 | -0.006 | -0.005 | 0.005 | 0.000 | 0.003 | 0.002 | 0.004 |
| DIA_FVENCE | -0.004 | -0.028 | -0.004 | -0.031 | -0.031 | 0.567 | 1.000 | 0.567 | 0.039 | -0.009 | 0.007 | 0.025 | 0.006 | -0.026 | 0.006 | 0.003 | 0.018 | 0.017 | 0.018 | 0.025 | -0.009 | 0.009 | -0.014 | 0.029 |
| DIA_OPE | -0.002 | 0.000 | -0.002 | 0.003 | 0.003 | 0.968 | 0.567 | 1.000 | 0.005 | -0.000 | 0.007 | 0.005 | -0.002 | -0.002 | -0.004 | 0.003 | -0.005 | -0.006 | -0.005 | 0.005 | -0.000 | 0.001 | 0.001 | 0.005 |
| ESPROVEED | 0.116 | 0.003 | 0.116 | 0.002 | 0.002 | 0.004 | 0.039 | 0.005 | 1.000 | 0.124 | 0.169 | 0.063 | 0.009 | 0.026 | 0.009 | 0.000 | 0.000 | 0.035 | 0.005 | 0.061 | 0.124 | 0.001 | 0.067 | 0.500 |
| ICONTRATO | 0.350 | 0.297 | 0.350 | -0.068 | -0.068 | 0.000 | -0.009 | -0.000 | 0.124 | 1.000 | 0.099 | 0.337 | 0.005 | 0.001 | 0.005 | 0.456 | -0.294 | -0.278 | -0.294 | 0.336 | 1.000 | 0.008 | 0.140 | 0.445 |
| IORDEN | 0.034 | 0.019 | 0.034 | 0.032 | 0.032 | 0.006 | 0.007 | 0.007 | 0.169 | 0.099 | 1.000 | 0.080 | -0.001 | -0.006 | -0.001 | 0.008 | -0.118 | -0.110 | -0.118 | 0.033 | 0.099 | 0.043 | 0.152 | 0.081 |
| ITINSTR | 0.222 | 0.042 | 0.222 | 0.037 | 0.037 | 0.005 | 0.025 | 0.005 | 0.063 | 0.337 | 0.080 | 1.000 | 0.013 | 0.033 | 0.013 | 1.000 | 0.000 | 0.010 | 0.000 | 1.000 | 0.337 | 0.044 | 0.028 | 0.304 |
| MES_FLIQ | -0.027 | -0.021 | -0.027 | 0.002 | 0.002 | -0.005 | 0.006 | -0.002 | 0.009 | 0.005 | -0.001 | 0.013 | 1.000 | 0.782 | 0.999 | 0.003 | -0.003 | -0.004 | -0.003 | 0.005 | 0.005 | -0.004 | -0.005 | 0.009 |
| MES_FVENCE | -0.017 | 0.031 | -0.017 | 0.089 | 0.089 | -0.002 | -0.026 | -0.002 | 0.026 | 0.001 | -0.006 | 0.033 | 0.782 | 1.000 | 0.782 | 0.004 | -0.045 | -0.044 | -0.045 | 0.030 | 0.001 | -0.012 | -0.007 | 0.030 |
| MES_OPE | -0.027 | -0.022 | -0.027 | -0.000 | -0.000 | -0.003 | 0.006 | -0.004 | 0.009 | 0.005 | -0.001 | 0.013 | 0.999 | 0.782 | 1.000 | 0.004 | -0.003 | -0.004 | -0.003 | 0.006 | 0.005 | -0.004 | -0.005 | 0.009 |
| MONEDA | 0.010 | 0.000 | 0.010 | 0.000 | 0.000 | 0.004 | 0.003 | 0.003 | 0.000 | 0.456 | 0.008 | 1.000 | 0.003 | 0.004 | 0.004 | 1.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.456 | 0.000 | 0.000 | 0.006 |
| MONTO | -0.102 | -0.141 | -0.102 | -0.219 | -0.219 | -0.005 | 0.018 | -0.005 | 0.000 | -0.294 | -0.118 | 0.000 | -0.003 | -0.045 | -0.003 | 0.000 | 1.000 | 0.965 | 1.000 | 0.000 | -0.294 | -0.078 | -0.062 | 0.001 |
| MONTO_ASIGNADO | -0.101 | -0.138 | -0.101 | -0.215 | -0.215 | -0.006 | 0.017 | -0.006 | 0.035 | -0.278 | -0.110 | 0.010 | -0.004 | -0.044 | -0.004 | 0.000 | 0.965 | 1.000 | 0.965 | 0.010 | -0.278 | -0.079 | -0.068 | 0.046 |
| MONTO_REAL | -0.102 | -0.140 | -0.102 | -0.218 | -0.218 | -0.005 | 0.018 | -0.005 | 0.005 | -0.294 | -0.118 | 0.000 | -0.003 | -0.045 | -0.003 | 0.000 | 1.000 | 0.965 | 1.000 | 0.000 | -0.294 | -0.078 | -0.062 | 0.004 |
| NTINSTR | 0.086 | 0.042 | 0.086 | 0.038 | 0.038 | 0.005 | 0.025 | 0.005 | 0.061 | 0.336 | 0.033 | 1.000 | 0.005 | 0.030 | 0.006 | 1.000 | 0.000 | 0.010 | 0.000 | 1.000 | 0.336 | 0.044 | 0.026 | 0.304 |
| NUMERO_CLIENTE | 0.350 | 0.297 | 0.350 | -0.068 | -0.068 | 0.000 | -0.009 | -0.000 | 0.124 | 1.000 | 0.099 | 0.337 | 0.005 | 0.001 | 0.005 | 0.456 | -0.294 | -0.278 | -0.294 | 0.336 | 1.000 | 0.008 | 0.140 | 0.445 |
| PLAZOREF | 0.056 | 0.098 | 0.056 | 0.296 | 0.296 | 0.003 | 0.009 | 0.001 | 0.001 | 0.008 | 0.043 | 0.044 | -0.004 | -0.012 | -0.004 | 0.000 | -0.078 | -0.079 | -0.078 | 0.044 | 0.008 | 1.000 | 0.107 | 0.000 |
| TASA | 0.290 | 0.255 | 0.290 | 0.048 | 0.048 | 0.002 | -0.014 | 0.001 | 0.067 | 0.140 | 0.152 | 0.028 | -0.005 | -0.007 | -0.005 | 0.000 | -0.062 | -0.068 | -0.062 | 0.026 | 0.140 | 0.107 | 1.000 | 0.043 |
| TIPO_PERSONA | 0.097 | 0.000 | 0.097 | 0.000 | 0.000 | 0.004 | 0.029 | 0.005 | 0.500 | 0.445 | 0.081 | 0.304 | 0.009 | 0.030 | 0.009 | 0.006 | 0.001 | 0.046 | 0.004 | 0.304 | 0.445 | 0.000 | 0.043 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| NUMERO_CLIENTE | ESPROVEED | TIPO_PERSONA | NOMBRE | NOMLARGO | RFC | NLINEA | ICONTRATO | IORDEN | FOPER | AÑO_OPE | MES_OPE | DIA_OPE | FLIQ | AÑO_FLIQ | MES_FLIQ | DIA_FLIQ | CPZO_DE | CPZO_A | PLAZOREF | FVENCE | AÑO_FVENCE | MES_FVENCE | DIA_FVENCE | IINSTR | ITINSTR | NTINSTR | TASA | MONEDA | MONTO | MONTO_ASIGNADO | MONTO_REAL | FECHA_REGISTRO | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1040153 | True | Moral Nacional no Gravable | BANXICO | BANCO DE MEXICO | BNM840515VB2 | 01040153 | 1040153 | 430215 | 2020-11-12 | 2020 | 11 | 12 | 2020-11-12 00:00:00 | 2020 | 11 | 12 | 4942 | 4942 | 1 | 2034-05-25 | 2034 | 5 | 25 | DEPBANX2 | OTROS | Otros Instrumentos | 4.25 | MXP | 3.302570e+09 | 3.302570e+09 | 3.302570e+09 | 2020-11-12 |
| 1 | 51000 | False | Cuentas Propias | GARANTIAS CREDITO | GARANTIAS CREDITO | NFI3406305T0 | 00051000 | 51000 | 430214 | 2020-11-12 | 2020 | 11 | 12 | 2020-11-12 00:00:00 | 2020 | 11 | 12 | 4942 | 4942 | 1 | 2034-05-25 | 2034 | 5 | 25 | DEPBANX2 | OTROS | Otros Instrumentos | 4.25 | MXP | 3.297121e+09 | 3.297121e+09 | 3.297121e+09 | 2020-11-12 |
| 2 | 1040153 | True | Moral Nacional no Gravable | BANXICO | BANCO DE MEXICO | BNM840515VB2 | 01040153 | 1040153 | 430100 | 2020-11-12 | 2020 | 11 | 12 | 2020-11-12 00:00:00 | 2020 | 11 | 12 | 4942 | 4942 | 1 | 2034-05-25 | 2034 | 5 | 25 | DEPBANX2 | OTROS | Otros Instrumentos | 4.25 | MXP | 3.302570e+09 | 0.000000e+00 | 3.308033e+09 | 2020-11-12 |
| 3 | 51000 | False | Cuentas Propias | GARANTIAS CREDITO | GARANTIAS CREDITO | NFI3406305T0 | 00051000 | 51000 | 430063 | 2020-11-12 | 2020 | 11 | 12 | 2020-11-12 00:00:00 | 2020 | 11 | 12 | 4942 | 4942 | 1 | 2034-05-25 | 2034 | 5 | 25 | DEPBANX2 | OTROS | Otros Instrumentos | 4.25 | MXP | 3.302570e+09 | 0.000000e+00 | 3.308033e+09 | 2020-11-12 |
| 4 | 1040153 | True | Moral Nacional no Gravable | BANXICO | BANCO DE MEXICO | BNM840515VB2 | 01040153 | 1040153 | 329069 | 2020-04-01 | 2020 | 4 | 1 | 2020-04-01 00:00:00 | 2020 | 4 | 1 | 5167 | 5167 | 1 | 2034-05-25 | 2034 | 5 | 25 | DEPBANX2 | OTROS | Otros Instrumentos | 6.50 | MXP | 5.217592e+09 | 5.217592e+09 | 5.217592e+09 | 2020-04-01 |
| 5 | 51000 | False | Cuentas Propias | GARANTIAS CREDITO | GARANTIAS CREDITO | NFI3406305T0 | 00051000 | 51000 | 329045 | 2020-04-01 | 2020 | 4 | 1 | 2020-04-01 00:00:00 | 2020 | 4 | 1 | 5167 | 5167 | 1 | 2034-05-25 | 2034 | 5 | 25 | DEPBANX2 | OTROS | Otros Instrumentos | 6.50 | MXP | 5.205281e+09 | 5.205281e+09 | 5.205281e+09 | 2020-04-01 |
| 6 | 51000 | False | Cuentas Propias | GARANTIAS CREDITO | GARANTIAS CREDITO | NFI3406305T0 | 00051000 | 51000 | 136313 | 2014-11-06 | 2014 | 11 | 6 | 2014-11-06 00:00:00 | 2014 | 11 | 6 | 7140 | 7140 | 1 | 2034-05-25 | 2034 | 5 | 25 | DEPBANX2 | OTROS | Otros Instrumentos | 3.00 | MXP | 3.408039e+08 | 3.408039e+08 | 3.408039e+08 | 2014-11-06 |
| 7 | 1040153 | True | Moral Nacional no Gravable | BANXICO | BANCO DE MEXICO | BNM840515VB2 | 01040153 | 1040153 | 136308 | 2014-11-06 | 2014 | 11 | 6 | 2014-11-06 00:00:00 | 2014 | 11 | 6 | 7140 | 7140 | 1 | 2034-05-25 | 2034 | 5 | 25 | DEPBANX2 | OTROS | Otros Instrumentos | 3.00 | MXP | 3.408039e+08 | 3.408039e+08 | 3.408039e+08 | 2014-11-06 |
| 8 | 51000 | False | Cuentas Propias | GARANTIAS CREDITO | GARANTIAS CREDITO | NFI3406305T0 | 00051000 | 51000 | 121365 | 2014-10-09 | 2014 | 10 | 9 | 2014-10-09 00:00:00 | 2014 | 10 | 9 | 7168 | 7168 | 1 | 2034-05-25 | 2034 | 5 | 25 | DEPBANX2 | OTROS | Otros Instrumentos | 3.00 | MXP | 3.408038e+08 | 3.408038e+08 | 3.408038e+08 | 2014-10-09 |
| 9 | 1040153 | True | Moral Nacional no Gravable | BANXICO | BANCO DE MEXICO | BNM840515VB2 | 01040153 | 1040153 | 121330 | 2014-10-09 | 2014 | 10 | 9 | 2014-10-09 00:00:00 | 2014 | 10 | 9 | 7168 | 7168 | 1 | 2034-05-25 | 2034 | 5 | 25 | DEPBANX2 | OTROS | Otros Instrumentos | 3.00 | MXP | 3.408038e+08 | 3.408038e+08 | 3.408038e+08 | 2014-10-09 |
| NUMERO_CLIENTE | ESPROVEED | TIPO_PERSONA | NOMBRE | NOMLARGO | RFC | NLINEA | ICONTRATO | IORDEN | FOPER | AÑO_OPE | MES_OPE | DIA_OPE | FLIQ | AÑO_FLIQ | MES_FLIQ | DIA_FLIQ | CPZO_DE | CPZO_A | PLAZOREF | FVENCE | AÑO_FVENCE | MES_FVENCE | DIA_FVENCE | IINSTR | ITINSTR | NTINSTR | TASA | MONEDA | MONTO | MONTO_ASIGNADO | MONTO_REAL | FECHA_REGISTRO | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1904344 | 1064769 | True | Moral Nacional no Gravable | CJF FISO 80692 | NAFIN FIDEICOMISO PENSIONES COMPLEMENTARIAS DE MAGISTRADOS Y JUECES JUB | CJF950204TL0 | 1064769 | 1064769 | 152563 | 2024-11-26 | 2024 | 11 | 26 | 2024-11-27 00:00:00 | 2024 | 11 | 27 | 36 | 36 | 1 | 2025-01-02 | 2025 | 1 | 2 | BONDESF | GUBERR | PAPEL GUBERNAMENTAL | 10.372 | MXP | 1.005706e+08 | 1.005706e+08 | 1.005706e+08 | 2024-11-26 |
| 1904345 | 1064769 | True | Moral Nacional no Gravable | CJF FISO 80692 | NAFIN FIDEICOMISO PENSIONES COMPLEMENTARIAS DE MAGISTRADOS Y JUECES JUB | CJF950204TL0 | 1064769 | 1064769 | 152550 | 2024-11-26 | 2024 | 11 | 26 | 2024-11-27 00:00:00 | 2024 | 11 | 27 | 92 | 92 | 1 | 2025-02-27 | 2025 | 2 | 27 | BONDESF | GUBERR | PAPEL GUBERNAMENTAL | 10.375 | MXP | 1.005588e+08 | 1.005588e+08 | 1.005588e+08 | 2024-11-26 |
| 1904346 | 1064811 | True | Moral Nacional no Gravable | TEP FISO 80694 | NAFIN, FIDEICOMISO DE ADMON Y FUENTE DE PAGO 80694, FISO APOYOS MEDICOS | TEP961122B8A | 1064811 | 1064811 | 152548 | 2024-11-26 | 2024 | 11 | 26 | 2024-11-27 00:00:00 | 2024 | 11 | 27 | 36 | 36 | 1 | 2025-01-02 | 2025 | 1 | 2 | BONDESF | GUBERR | PAPEL GUBERNAMENTAL | 10.372 | MXP | 9.051352e+05 | 9.051352e+05 | 9.051352e+05 | 2024-11-26 |
| 1904347 | 1064806 | True | Moral Nacional no Gravable | CJF FISO 80694 | NAFIN FIDEICOMISO APOYOS MED. COMPLEMENTARIOS Y APOYO ECONOMICO EXT PJF | CJF950204TL0 | 1064806 | 1064806 | 152546 | 2024-11-26 | 2024 | 11 | 26 | 2024-11-27 00:00:00 | 2024 | 11 | 27 | 36 | 36 | 1 | 2025-01-02 | 2025 | 1 | 2 | BONDESF | GUBERR | PAPEL GUBERNAMENTAL | 10.372 | MXP | 1.609129e+06 | 1.609129e+06 | 1.609129e+06 | 2024-11-26 |
| 1904348 | 1064796 | True | Moral Nacional no Gravable | CJF FISO 80693 | NAFIN, FISO MANTENIMIENTO DE CASA HABITACION DE MAGISTRADOS Y JUECE | CJF950204TL0 | 1064796 | 1064796 | 152543 | 2024-11-26 | 2024 | 11 | 26 | 2024-11-27 00:00:00 | 2024 | 11 | 27 | 36 | 36 | 1 | 2025-01-02 | 2025 | 1 | 2 | BONDESF | GUBERR | PAPEL GUBERNAMENTAL | 10.372 | MXP | 2.514264e+06 | 2.514264e+06 | 2.514264e+06 | 2024-11-26 |
| 1904349 | 1053131 | True | Moral Nacional no Gravable | FEFA | FONDO ESPECIAL PARA EL FINANCIAMIENTO AGROPECUARIO (FEFA) | FEF650826K41 | 01053131 | 1053131 | 298161 | 2006-06-09 | 2006 | 6 | 9 | 2006-06-09 00:00:00 | 2006 | 6 | 9 | 7 | 7 | 0 | 2006-06-16 | 2006 | 6 | 16 | OTROSBANC | Instrumentos con man fisc | 7.030 | MXP | 1.230000e+09 | 0.000000e+00 | 1.230000e+09 | 2006-06-09 | |
| 1904350 | 1062813 | True | Moral Nacional no Gravable | BLK / BLKLIQP | BLK FONDEO GUBERNAMENTALES MEXICO EXENTOS, S.A. DE C.V., F.I.I.D. | HLP010918LTA | 01062813 | 1062813 | 176285 | 2019-05-24 | 2019 | 5 | 24 | 2019-05-24 00:00:00 | 2019 | 5 | 24 | 3 | 3 | 0 | 2019-05-27 | 2019 | 5 | 27 | GUBERN | PAPEL GUBERNAMENTAL | 7.360 | MXP | 6.529709e+08 | 0.000000e+00 | 6.529709e+08 | 2019-05-24 | |
| 1904351 | 1064295 | True | Moral Nacional no Gravable | PRINCIPAL PENSIONES CAPITA | PRINCIPAL PENSIONES S.A. DE C.V. CAPITAL T | PPE990528GD0 | 1064295 | 1064295 | 175108 | 2019-05-23 | 2019 | 5 | 23 | 2019-05-23 00:00:00 | 2019 | 5 | 23 | 4 | 4 | 0 | 2019-05-27 | 2019 | 5 | 27 | GUBERN | PAPEL GUBERNAMENTAL | 8.260 | MXP | 5.520562e+04 | 0.000000e+00 | 5.520562e+04 | 2019-05-23 | |
| 1904352 | 1063782 | True | Moral Nacional no Gravable | AZT8589 | SIEFORE AZTECA BASICA 85-89 S.A. DE C.V. | SAB080110UG5 | 1063782 | 1063782 | 894775 | 2018-07-05 | 2018 | 7 | 5 | 2018-07-05 00:00:00 | 2018 | 7 | 5 | 1 | 1 | 0 | 2018-07-06 | 2018 | 7 | 6 | GUBERN | PAPEL GUBERNAMENTAL | 7.840 | MXP | 2.522300e+08 | 0.000000e+00 | 2.522300e+08 | 2018-07-05 | |
| 1904353 | 1063238 | True | Moral Nacional no Gravable | BLIQUID | BURSALIQUIDO, S.A. DE C.V. SOC DE INV EN INST DE DEUDA | BUR9001257R2 | 01063238 | 1063238 | 309906 | 2011-01-21 | 2011 | 1 | 21 | 2011-01-21 00:00:00 | 2011 | 1 | 21 | 3 | 3 | 0 | 2011-01-24 | 2011 | 1 | 24 | GUBERN | PAPEL GUBERNAMENTAL | 4.550 | MXP | 7.212859e+05 | 0.000000e+00 | 7.212859e+05 | 2011-01-21 |